Release 10.1A: OpenEdge Data Management:
Database Administration

PROSTRCT STATISTICS qualifier

Displays statistics about storage information about the specified database.

Syntax

prostrct statistics db-name

Parameters

db-name

Specifies the database whose storage information you want.

PROSTRCT STATISTICS displays the following information:

Database name.
Primary database block size and the before-image and after-image block sizes.
Storage area and each extent within it.
Total number of active blocks allocated for each data area.
Total number of blocks for each data area.
Total number of empty blocks in each data area.
Total number of extent blocks for each data area.
Total records per block for each data area.
Total number of all blocks (active blocks, active free blocks, and empty blocks).
Date and time of the last full database backup.

Notes

When PROSTRCT STATISTICS is run against a database that is in use, values may be changing as the display is output.
Do not run this utility against a database that has crashed. You must recover the database first.
A void database cannot be accessed by this command.
See Chapter 14, "Maintaining Database Structure," for more information about the STATISTICS qualifier with the PROSTRCT utility.